/**
 * 
 */
package com.cmpanyandi.elearning.wordsdriller.model;

import com.cmpanyandi.elearning.utils.db.DBDescriptor;

/**
 * This is configuration file for application
 * @author wojtek
 *
 */
public class Configuration {

    
    
    
    private static int version = 6;
    public static DBDescriptor DEFAULT_DICTIONARY_DB = new DBDescriptor("wordsdriller", version);
    
       
    static {
	DEFAULT_DICTIONARY_DB.addCreateStatement("create table dictionary (_id integer primary key autoincrement, name text not null, description text);");
	DEFAULT_DICTIONARY_DB.addCreateStatement("create table dictionary_item (_id integer primary key autoincrement, name text not null, description text, context text, dictionary_id integer not null);");
	DEFAULT_DICTIONARY_DB.addUpdateStatement(version, "drop table dictionary_item;");
	DEFAULT_DICTIONARY_DB.addUpdateStatement(version, "drop table dictionary;");
	DEFAULT_DICTIONARY_DB.addUpdateStatement(version, "create table dictionary (_id integer primary key autoincrement, name text not null, description text);");
	DEFAULT_DICTIONARY_DB.addUpdateStatement(version, "create table dictionary_item (_id integer primary key autoincrement, name text not null, description text, context text, dictionary_id integer not null);");
	
    }
    
    
    
    
    
}
